SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436852 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436852 [ RunTime:0.003239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034645,1007003,319361,775227,496108,562393,736193,676172,803717,330456,258843,92142,244684,754890,676298,929131,1336,961449,1029927,410939,884314,248698,1038381,279075,617824,272455,637223,152959,422323,822298,510767,424684,369770,84342,1004542,358676,1031027,856838,119797,1042833,759897,585814,227926,612250,670272,398668,478876,163305,685279,123199,543820,584162,486456,194020,274487,158064,250614,475686,448513,959705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]