SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522735 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522735 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521127,957757,557749,490049,1025036,898103,119246,426147,407481,256291,237970,774916,258621,776452,502415,56472,124570,743264,172075,609729,700019,263349,426320,941210,230947,571845,372399,188770,26119,1029711,388829,457051,293243,938309,493148,843856,886419,149664,115992,714499,863004,764420,891612,139583,121430,302154,324712,794131,1035239,537927,666652,432205,242576,98099,862838,478785,601639,566382,904147,1012685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522735 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522735 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]