SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333143 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333143 [ RunTime:0.002358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874437,817285,419657,1045336,717552,201067,874333,161060,156385,1043615,173255,826999,1007836,229952,457783,1042873,547805,126393,597457,111019,1033812,1030793,183575,188794,808705,80105,880133,228,888080,843522,562774,921327,334638,231721,894149,716986,102548,130395,674787,333292,918549,165919,17377,46750,1029198,236114,374752,289371,151721,1008098,19890,846474,730509,152135,323658,366792,36645,295370,292500,455284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003240s ]