SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005874s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404930 LIMIT 1 [ RunTime:0.001329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404930 [ RunTime:0.004792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804574,57483,528465,677545,565670,246736,750736,354575,866548,534893,218922,842472,630861,439413,33287,516796,881565,704484,304551,240931,874457,925439,810691,242407,792304,200571,775063,257567,141724,808725,968031,461556,683987,298103,837088,129688,337730,393201,159290,19681,857426,301346,171682,611622,734581,269040,973796,947850,785347,90027,869801,964395,335401,306442,751289,248362,735136,313449,538573,358448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]