SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 214330 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 214330 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311594,40078,1012418,994498,721053,855669,573739,414796,643703,759698,272365,88318,969752,217685,121919,502369,306780,894027,408073,736917,242717,779710,936729,199244,741209,902752,405464,924528,898428,847848,32968,313244,174154,537195,261383,64446,831458,1031720,660087,617227,191631,643801,15449,633388,321810,950570,515149,482363,483182,583358,450213,698711,764918,942243,747804,235604,75749,309738,466429,407057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 214330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 214330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]