SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023091 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023091 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646949,936738,313459,823421,34963,191463,699297,364509,886404,943110,429792,659153,888068,263881,1008669,751443,349879,1043075,638028,130060,925508,254561,104826,181645,105640,301616,402006,1033057,540695,964637,536064,804169,491596,372078,552547,992736,447042,563285,178488,141748,887368,472655,113751,919921,67557,94158,337581,201694,460582,552289,54039,992759,803371,59473,486365,274580,86935,788019,814513,417372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]