SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417771 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417771 [ RunTime:0.002769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251418,185723,78907,428583,1041101,416915,656894,881810,245997,613815,526677,910476,868685,82297,919371,563312,574855,769322,397679,685559,436989,815204,746075,459038,604196,27054,164071,876971,925605,287606,992097,79927,685286,375281,426058,197035,562612,363006,48744,398028,281382,132235,223538,504361,680802,490792,818270,1023781,535398,997664,53836,113140,353700,660324,472956,167039,422445,362590,166750,217096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]