SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103523 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103523 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401345,595186,484133,91455,480884,578711,863934,702577,827150,253218,170327,1006910,813684,517528,506697,979103,755251,567209,76132,813835,327196,981347,510175,54388,103138,616881,432018,558135,127023,104316,766230,672955,486849,612715,205562,591679,1005673,33444,35877,879702,291156,540502,819056,157439,342777,314284,581715,873271,493861,299903,200115,245582,208465,346438,225125,199783,578096,419663,591642,275008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]