SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446698 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446698 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024641,305614,591707,141909,290529,704657,741522,475387,354893,170605,213091,804543,21588,165931,283452,798746,484025,434184,79160,23634,526978,478250,1006606,982086,203079,267986,163972,471194,983432,501680,257480,734042,328597,710639,900084,221156,227660,359780,390586,700838,817267,961122,875208,55408,425965,176358,973058,780297,483505,404321,399691,671204,499564,202340,753644,211554,356929,605907,981273,28414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]