SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198355 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198355 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540228,63379,939146,733716,959285,857389,205098,92266,776483,747583,618287,755716,146945,759514,796683,896921,542831,327810,540,765505,848654,495985,356729,525480,694644,506024,383355,818272,288614,469519,676882,929342,755407,518182,819415,767888,155651,219561,78774,1021774,777057,392210,501780,122557,32021,432060,669665,806276,183238,1046073,998657,847326,404246,534464,175257,347746,195237,805065,636837,307660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198355 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198355 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]