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` = 411044 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411044 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859384,778136,537953,325546,104971,166817,323547,611736,302952,368184,947650,404028,491372,26834,661304,684226,673027,818894,204020,1033413,643565,693898,254797,280637,788755,187646,567074,53100,803453,910602,916809,243867,212061,975293,435069,399047,346962,416256,127379,743201,1022499,151114,599097,891802,853574,29162,719632,898851,319162,33615,1035997,421185,155203,761501,171492,656508,397500,759455,789737,717530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]