SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429101 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429101 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396150,392534,513006,431722,810755,66873,777999,445972,775853,786723,948207,842185,651435,345417,178253,115054,631449,27426,559506,842480,515282,432919,9412,354259,159529,457254,953297,701850,1027819,688327,648087,337,559408,266698,890669,7783,200610,38909,1004032,756114,329935,512569,410393,336195,95808,680829,1025473,351604,415372,1042507,696942,47760,80303,334360,510984,475600,450927,319141,490895,300025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]