SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419398 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419398 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323710,965217,216938,68044,560809,915065,246893,670314,675797,294381,558508,440544,994394,910494,346327,164094,873589,1033220,145814,649129,378044,531168,928787,644772,42666,673905,687389,107699,899384,916193,998210,220351,1022822,647031,491662,180794,708824,385870,509989,670273,197443,53675,1041867,134528,286389,1004668,858408,175062,244521,956702,238171,766430,879536,198811,29305,527358,617247,370636,271614,74802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]