SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451475 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451475 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245182,519710,987225,898604,610884,102870,639449,1038895,186523,108288,257264,483038,500182,387087,10523,490002,415644,15487,244085,323933,369134,698824,309195,313033,224492,372886,843135,981794,65007,584958,710535,387447,932773,377173,807055,590885,431096,283574,870369,797369,2021,1013427,129969,321270,430947,410224,49774,230683,102877,631399,572927,937617,680131,576138,337861,650723,592002,977981,1012146,454513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]