SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28617 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28617 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620575,723810,638110,322431,466779,366456,222184,136753,55115,1046244,503202,903999,463617,115620,373816,862049,565302,531342,746168,1010666,185026,107734,45961,768317,332563,199636,691899,218016,658103,840544,36983,397268,512311,517359,278149,972793,853309,847109,305267,682949,866838,755554,543269,985355,774441,274001,998443,1007485,749105,518274,569808,638469,439994,633669,562271,451512,365004,858330,552612,248628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]