SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020315 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020315 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842313,169613,499543,696448,206382,693528,768283,630329,921996,500043,804486,200547,455301,167445,221116,105320,213445,686539,577645,245567,360372,78396,251025,881026,458966,288408,336141,45378,165422,463767,478779,974650,350061,784642,780322,835677,590354,1038931,403329,149407,335931,712645,717665,913645,133026,162720,134358,448866,135071,830539,323984,567103,382104,961717,382689,880475,20166,869693,160531,761279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]