SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444271 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444271 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970266,866145,362151,804856,805592,190361,523600,564192,995578,112888,596362,753938,725650,259409,1004257,495225,162928,60287,330243,857693,324934,181572,207618,230974,641461,551104,92182,661796,543970,130738,22461,193961,567345,862026,587456,933144,206779,115875,585827,612262,499896,325165,885502,63910,306498,453617,279678,843948,1023589,454766,711476,841091,1048004,968366,105079,156587,792931,770017,40847,451359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]