SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500176 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500176 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814034,180131,421216,32514,475968,277675,316571,880004,402322,351640,266259,613994,767231,917326,583055,420015,941668,722532,783422,491048,697268,339411,448863,942610,396238,453269,852611,251633,246060,145792,484995,162821,443945,41620,142684,810165,601622,840502,405871,788429,700078,572690,425604,634684,63477,606846,731208,830819,443905,935130,548555,260773,785569,499198,598867,955078,607591,205709,162779,823157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]