SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631568 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631568 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850388,362452,415053,587983,1034526,968053,1039032,706191,515614,502198,176879,134679,25106,461482,580512,313336,494827,640786,291380,806822,470364,915372,1019318,404019,8278,42439,123482,528344,362615,564990,478020,934192,942457,163847,157328,824103,31719,586658,367155,42115,827781,116132,726602,373728,431648,620538,388394,698283,996599,157654,743887,815400,62148,334697,278801,647918,930674,898034,381851,402910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]