SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503563 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503563 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497271,395651,932926,375663,259516,168826,823474,79823,111491,130987,877383,690171,208290,470845,767584,62002,726409,367345,23842,769724,105821,44890,412271,457283,993418,403517,156079,1024688,163394,225152,1001557,1006860,959927,42480,122142,423889,282195,511662,756050,129826,349876,730955,624997,625670,711679,274370,278089,331583,164999,840194,14266,156787,731217,94732,298059,373073,812123,878334,371538,113691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]