SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563538 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563538 [ RunTime:0.003218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459037,450351,227602,644258,529469,38162,967848,762352,733733,181559,539723,444206,60217,258959,979538,350228,31492,57204,154519,684446,370019,736706,666990,385123,1020037,540697,63433,313614,688017,286151,600927,527764,747970,238956,338145,621828,759330,229073,200894,631027,952740,815851,27730,365715,4661,905744,900945,1023742,701435,509616,323381,47158,924074,75557,750453,309212,667765,68048,334378,70419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001606s ]