SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52501 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52501 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270871,956046,310664,859951,752997,886134,291099,817763,172926,150147,301445,67522,123043,680650,661593,793630,147372,1043932,212445,602828,447561,649226,200201,959039,167074,571801,854973,70487,346098,908561,35603,939085,641882,13541,226161,24442,965945,720086,967409,927644,408251,968152,9931,157851,878610,100060,511726,349607,239893,1026416,110570,873489,769609,488251,829572,316281,923742,1028306,741550,951177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000847s ]