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` = 1005241 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005241 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889419,922485,162500,63923,892809,493369,902832,1024895,860884,551080,196857,351581,243531,385046,916799,274026,78885,627934,3090,562986,146311,168169,867188,925660,297106,141667,452777,330216,171148,797705,540642,412861,294212,67360,968442,745257,348671,204663,1024583,321272,1046252,253869,416887,233164,478239,150875,488547,790548,423012,491897,528737,967,433117,871476,392410,675236,389153,370825,328393,858243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]