SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563989 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563989 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51998,201038,426053,291827,563464,371058,948537,326596,938338,661577,162226,529959,609120,350230,818444,807722,375610,886731,391394,998866,97295,371605,194298,986740,586291,427595,1016710,950381,381092,414993,670810,566818,41696,490317,313601,861721,828164,520285,445583,697019,36652,519632,906996,1009329,119688,329009,170399,123957,44039,300898,206319,424960,715148,577127,127235,234275,935910,662725,1013094,1046320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]