SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253840 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253840 [ RunTime:0.003698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294137,445812,857078,711996,745495,1041393,19862,1026163,715124,651696,17956,521252,149591,934980,457748,529174,482750,1009745,749630,89861,3352,983210,35314,143854,339380,561938,815011,780026,1025648,271774,479783,685038,801737,869620,1034812,65758,622558,775339,293037,388285,326614,335839,2196,73822,928131,858503,927161,898437,259568,114408,559260,478720,177169,707255,258793,857974,462767,696584,985091,398872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]