SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 903898 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 903898 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786517,480124,1016139,320074,565514,453771,833349,617760,180505,916686,21686,281294,900318,695021,418098,240526,451497,466534,248035,795387,636622,260324,968075,523817,860474,4312,184713,730039,1043331,368411,773107,672586,138223,184721,994119,358659,292225,483290,327451,1033541,842252,649543,391913,1043432,861955,250795,112229,739402,222590,1008610,452163,223253,666215,243468,183708,551990,93451,198393,878121,935494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 903898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 903898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]