SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502829 LIMIT 1 [ RunTime:0.003168s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502829 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624719,219167,377579,657261,832284,493655,977806,767071,334273,63837,528553,364026,785021,400499,687765,625230,584802,432794,527753,270423,520930,819144,319201,383374,609599,587471,14038,391659,474664,629537,178909,1015230,522947,782657,642958,64157,206076,302299,937020,136460,358169,389933,358217,680346,466251,586026,375277,606583,590191,298782,797180,934081,988522,626355,848522,507342,914630,800883,936570,664287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]