SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 377856 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 377856 [ RunTime:0.002796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374180,612959,770484,975339,82241,483319,996789,319376,891604,634471,643080,47730,960893,56297,609698,449336,189050,80509,561590,342090,531968,225213,325914,338747,349420,227488,299876,731781,1043636,102602,711702,454697,987462,906183,379819,357979,201559,205680,563342,940605,113210,572346,766951,285902,71814,34778,63904,407979,100789,439314,94146,568694,879102,228586,789466,522596,844871,151711,835921,491269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 377856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 377856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]