SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19091 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19091 [ RunTime:0.003090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205963,286189,385468,570667,64632,76584,1467,498156,635241,672188,413515,264803,987394,237672,842657,433536,378141,858652,385164,901240,266416,1027496,169173,446678,803431,849099,315381,794334,642471,789805,538924,425795,795041,767285,866818,929423,528919,753817,385409,432217,224289,1045053,425730,684705,234922,737194,441133,589449,1007546,160587,554381,985490,927137,846909,1024517,565917,598986,139854,404063,771527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]