SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480599 LIMIT 1 [ RunTime:0.003389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480599 [ RunTime:0.007475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754055,735398,204688,527643,30908,538583,957740,181767,282467,97236,548741,377362,1005203,257499,762501,527550,125714,481430,467016,643340,960529,788697,374996,630100,283738,701074,251957,26640,290049,589928,341707,1000393,517586,405619,81072,193251,287079,64332,107277,331044,377425,621843,157599,324320,850672,709384,858309,637696,259801,937599,441571,727312,781488,250048,508426,875762,73032,318292,569571,24726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]