SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425621 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425621 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144722,108177,27679,537012,504934,901526,3962,582971,257550,710664,692224,870590,205652,464017,167491,498992,513099,1001890,288700,434982,593927,388234,947901,619648,121951,82437,144298,222479,462738,560104,1025465,484119,897788,258333,956719,632165,942496,1006285,270798,40052,264454,471353,1016813,881491,17638,276921,825210,190066,313773,674673,282180,537476,872634,610278,961528,247093,71877,561381,869337,298015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]