SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263842 LIMIT 1 [ RunTime:0.000664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263842 [ RunTime:0.002958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841460,925090,986424,402311,974617,223653,102989,850039,411298,603986,315448,311617,800901,926872,642241,876927,504403,619052,626175,817061,157961,103528,248177,911498,1027978,693398,296529,244514,638271,1039245,365867,907405,147196,162362,415607,932823,230523,836781,578159,570396,684091,975406,388281,326930,771490,967540,609376,1007911,1001813,723167,864791,723464,160180,70070,974421,221389,569094,710793,1034031,427532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000775s ]