SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589218 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589218 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29338,979977,649857,431036,600776,847951,225647,30500,587778,803823,772603,784860,54320,638206,243493,763014,440230,51567,270852,549120,50097,1030725,134105,569281,927854,355563,932899,321763,283697,861316,532971,1026579,61213,66483,146500,425287,712644,202133,726789,239352,185698,425114,588251,841626,638794,1028186,169186,597099,878642,851657,566851,50723,925526,367295,1019958,135803,159293,371769,688495,994838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001722s ]