SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405073 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405073 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892579,130027,207790,887422,846493,619182,667380,389407,4522,425211,987346,367959,526945,350852,654676,377451,869413,425871,375427,797820,836783,392617,501950,97903,849332,538770,284326,97482,354273,457415,476363,743252,720357,242114,559089,1040095,654900,109596,862358,491075,199364,262788,1030524,1037784,759998,181334,733577,41837,815231,382795,665080,63032,623654,269805,255094,804371,910846,430960,693930,737042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]