SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440907 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440907 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118067,92390,374289,957491,259216,44518,223754,655346,779582,476015,489341,531156,863069,220917,43979,297827,214556,316175,738515,380657,1039435,715260,839061,21538,334107,663471,374398,972721,709483,711861,843226,371590,364238,508311,196363,457747,289147,350722,30771,835682,1041022,14551,767973,116693,244044,199430,739616,662410,814073,467327,991170,763051,483231,899315,1009089,800144,641967,65276,892276,511400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]