SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529480 LIMIT 1 [ RunTime:0.000607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529480 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039793,2217,374248,368411,770621,869056,237412,28876,364448,201178,959691,746707,844039,909186,101501,630716,986561,24689,185682,497840,842473,60609,735662,262782,356466,160735,880313,86472,1009647,802839,230047,64809,350044,616147,521458,642126,437914,933740,193611,125416,869806,490463,44324,434386,616930,785174,219728,347589,624527,112298,611082,513868,33422,12949,219757,719849,861814,830759,520536,873763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]