SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193870 LIMIT 1 [ RunTime:0.000588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193870 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9330,38693,549368,642093,1024679,137046,699764,432808,512703,936756,56368,511417,493842,611828,967903,11821,438521,749774,198556,716263,871192,650514,983659,218606,47793,484213,781711,1029892,98705,782371,836174,854836,819177,457520,418544,403355,121574,1009038,925526,445165,641905,273662,720951,600956,594544,542930,200503,633967,282399,877255,1022332,865781,291257,499499,801296,480648,116851,638590,388248,661976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000856s ]