SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019891 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019891 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225784,589203,573302,132809,994246,651912,358070,260796,403405,183973,313671,940604,80484,255352,311447,664092,1034706,214617,1015489,1004789,1041058,917137,158710,848497,1034133,571418,265760,314723,409049,861386,1027693,220359,802983,50771,346893,737811,1026439,105810,300376,1043478,974198,303419,110297,842325,170779,655534,565094,849208,528060,823322,681738,915255,838794,383600,388151,171981,699052,227065,85188,140662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]