SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192682 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192682 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602673,632604,399811,667396,2689,236174,746352,608537,787562,804071,856401,926114,497871,164670,220219,655618,192875,262328,184135,959260,589601,931088,721632,392423,146701,591691,451485,665143,133267,530084,606624,74522,491391,118911,787113,423435,543059,934701,602886,294820,45682,607298,712462,64780,713963,270740,278844,793186,351868,887907,489917,283937,739035,189955,828019,203937,65255,751451,645110,456040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003921s ]