SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201024 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201024 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302523,339091,839393,539453,589786,417392,575955,347672,438199,866158,327823,176945,395999,982545,496090,414248,254918,984000,316252,89920,691280,920305,803763,722368,740153,588330,233579,956341,573739,1012390,44277,502000,291320,368681,883053,107437,929368,765636,792999,421923,629054,369908,150838,788220,826613,567424,306032,190713,724763,461756,259876,298267,905132,349050,730013,218430,512765,298865,858061,696298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]