SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195029 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195029 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516149,322222,342285,36051,842283,337844,1012398,563267,931847,801600,120810,941878,88152,177781,705444,795792,144836,827837,497213,296712,234459,539410,970245,792438,476614,597327,21303,680826,895538,577176,116628,787691,175478,238502,166779,337660,927601,36576,415669,445105,749754,26372,372379,92039,314755,175388,1000823,890478,229636,347116,413185,661090,466957,633947,655124,739921,273799,73533,1034142,719308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]