SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476845 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476845 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148367,306260,929904,893310,452562,119526,471116,365587,196464,257536,792491,45968,1030219,245285,388565,807531,143090,172781,871094,1017731,366860,941811,133017,691911,187319,462091,541027,108560,243136,508358,169526,787496,23896,154673,50120,62550,509780,525520,503122,860821,386794,564257,388467,258381,476207,563962,759728,327213,716416,1029476,417298,30359,758810,840819,437610,515,869272,424889,670375,121087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]