SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409654 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409654 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801791,1029495,867812,508871,167188,210376,666226,711585,213668,22231,963540,788990,360574,603824,67540,786426,914980,347758,640806,271900,884710,772640,524111,128885,222767,780619,202014,1024554,8084,137283,780073,171489,56602,209935,926917,217306,174552,912812,214882,859678,30563,102439,168417,229122,291405,89986,609486,193474,457281,580787,873009,172511,336610,745163,726442,261291,598927,270533,285142,961124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]