SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289613 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289613 [ RunTime:0.003144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417876,886225,517156,989556,710337,568248,110338,1002520,532578,565193,643995,32402,1041514,706797,741503,201794,633599,956033,536376,117806,155527,170354,902793,81302,1019413,587452,370549,444364,80678,261114,1024157,399071,907306,521986,97721,229678,825130,231736,855261,2377,929976,724485,419999,945970,511874,748117,1015325,620466,102099,767422,684711,451043,38062,285172,272594,615387,197110,659799,726420,446746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]