SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517719 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517719 [ RunTime:0.003753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15051,254455,44790,241550,371778,541466,49682,282446,374068,669577,931209,235953,509043,704989,821969,124145,377057,7213,90755,373414,424035,684119,543707,868211,158411,664085,864498,689958,901759,46878,659120,900843,439864,282167,991752,733510,817898,360172,1030808,408923,675875,761660,68559,178199,99269,834068,178565,469467,195522,795835,1029939,593581,606451,859083,938155,674772,523190,653601,982098,869873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517719 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517719 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]