SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391207 LIMIT 1 [ RunTime:0.001012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391207 [ RunTime:0.004691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038755,229000,431087,1023969,220072,312892,42411,92501,47689,879998,101987,760089,867331,798760,923872,711486,486241,253218,77321,954428,765726,397522,1041301,466626,210083,763246,574046,191308,39335,1005894,604111,336055,383560,334343,1042736,201899,380004,155903,44162,40083,1007999,595674,777493,657744,254052,97634,359439,22825,936932,718124,327154,201400,468426,268721,14409,305580,384254,406694,601502,214177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]