SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195475 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195475 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420733,352132,423022,968823,102131,115698,763548,393204,823146,811158,791353,749742,733526,487101,443600,863677,690758,202107,1014160,599214,449057,1037823,469687,1018543,460423,1014534,470340,428418,899102,447231,774729,336409,89474,638878,912693,626610,814660,213598,337027,92418,820551,324997,612205,686505,1017245,216654,201714,551934,132187,805065,788357,6512,1007368,473468,576958,1000039,733656,551026,551590,440140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]