SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538603 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538603 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181006,916888,87848,52035,779504,291968,194511,650442,373189,112931,840362,698764,362399,1034346,935041,923215,29074,955913,454153,412274,833856,867320,539801,1046777,447234,404094,932321,792679,9552,323859,740708,523818,673288,440867,940194,910652,442678,786608,63482,781098,404472,1027655,975041,409604,167207,546973,1031799,411498,820773,541191,824771,1035817,728982,1000335,793099,101425,442959,588538,559394,117663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]