SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585404 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585404 [ RunTime:0.003623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368668,11604,44828,741399,27279,865658,328195,485146,872432,884761,286367,225983,344815,753442,374790,500365,167434,1025191,538788,933194,450547,723206,286050,344364,841623,115268,167379,965290,638780,376969,600929,614537,829758,424255,310878,240690,544446,977590,157453,99803,292299,481517,698940,207503,792371,286692,1027090,496352,112802,155679,8311,8367,480046,676341,621638,682155,297311,512510,233313,726929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]