SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519461 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519461 [ RunTime:0.002802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173119,337814,232908,502895,947400,105797,946461,883733,42274,38146,1015549,457692,418341,567815,516013,817390,102465,258631,388456,349202,75446,341944,152240,752551,913100,289786,279340,103149,705610,898626,363530,10913,980701,311076,745702,163660,958829,172052,181104,372547,672130,917319,704462,575902,1026364,409135,352834,89923,581790,921963,924606,282360,972550,295868,108749,85743,565808,884465,733755,922876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]